/*
*
* OrderDepotShipExample.java
* @author yaokan
* @date 2021-01-08 17:27:05
*/
package com.steel.yfmall.cloud.assistant.po.oms;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderDepotShipExample {
    /**
     * order_depot_ship
     */
    protected String orderByClause;

    /**
     * order_depot_ship
     */
    protected boolean distinct;

    /**
     * order_depot_ship
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:order_depot_ship
     * @Title: OrderDepotShipExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-01-08 17:27:05
     */
    public OrderDepotShipExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:order_depot_ship
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-01-08 17:27:05
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:order_depot_ship
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-01-08 17:27:05
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:order_depot_ship
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-01-08 17:27:05
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:order_depot_ship
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-01-08 17:27:05
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:order_depot_ship
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-01-08 17:27:05
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:order_depot_ship
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-01-08 17:27:05
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:order_depot_ship
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-01-08 17:27:05
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:order_depot_ship
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-01-08 17:27:05
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:order_depot_ship
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-01-08 17:27:05
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:order_depot_ship
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-01-08 17:27:05
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title order_depot_ship表的实体类
     * @description order_depot_ship
     * @version 1.0
     * @author yaokan
     * @date 2021-01-08 17:27:05
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderSnIsNull() {
            addCriterion("order_sn is null");
            return (Criteria) this;
        }

        public Criteria andOrderSnIsNotNull() {
            addCriterion("order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSnEqualTo(String value) {
            addCriterion("order_sn =", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotEqualTo(String value) {
            addCriterion("order_sn <>", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnGreaterThan(String value) {
            addCriterion("order_sn >", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("order_sn >=", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLessThan(String value) {
            addCriterion("order_sn <", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLessThanOrEqualTo(String value) {
            addCriterion("order_sn <=", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLike(String value) {
            addCriterion("order_sn like", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotLike(String value) {
            addCriterion("order_sn not like", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnIn(List<String> values) {
            addCriterion("order_sn in", values, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotIn(List<String> values) {
            addCriterion("order_sn not in", values, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnBetween(String value1, String value2) {
            addCriterion("order_sn between", value1, value2, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotBetween(String value1, String value2) {
            addCriterion("order_sn not between", value1, value2, "orderSn");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIsNull() {
            addCriterion("depot_code is null");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIsNotNull() {
            addCriterion("depot_code is not null");
            return (Criteria) this;
        }

        public Criteria andDepotCodeEqualTo(String value) {
            addCriterion("depot_code =", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotEqualTo(String value) {
            addCriterion("depot_code <>", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeGreaterThan(String value) {
            addCriterion("depot_code >", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeGreaterThanOrEqualTo(String value) {
            addCriterion("depot_code >=", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLessThan(String value) {
            addCriterion("depot_code <", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLessThanOrEqualTo(String value) {
            addCriterion("depot_code <=", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLike(String value) {
            addCriterion("depot_code like", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotLike(String value) {
            addCriterion("depot_code not like", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIn(List<String> values) {
            addCriterion("depot_code in", values, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotIn(List<String> values) {
            addCriterion("depot_code not in", values, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeBetween(String value1, String value2) {
            addCriterion("depot_code between", value1, value2, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotBetween(String value1, String value2) {
            addCriterion("depot_code not between", value1, value2, "depotCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoIsNull() {
            addCriterion("invoice_no is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoIsNotNull() {
            addCriterion("invoice_no is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoEqualTo(String value) {
            addCriterion("invoice_no =", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoNotEqualTo(String value) {
            addCriterion("invoice_no <>", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoGreaterThan(String value) {
            addCriterion("invoice_no >", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_no >=", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoLessThan(String value) {
            addCriterion("invoice_no <", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoLessThanOrEqualTo(String value) {
            addCriterion("invoice_no <=", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoLike(String value) {
            addCriterion("invoice_no like", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoNotLike(String value) {
            addCriterion("invoice_no not like", value, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoIn(List<String> values) {
            addCriterion("invoice_no in", values, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoNotIn(List<String> values) {
            addCriterion("invoice_no not in", values, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoBetween(String value1, String value2) {
            addCriterion("invoice_no between", value1, value2, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceNoNotBetween(String value1, String value2) {
            addCriterion("invoice_no not between", value1, value2, "invoiceNo");
            return (Criteria) this;
        }

        public Criteria andShippingStatusIsNull() {
            addCriterion("shipping_status is null");
            return (Criteria) this;
        }

        public Criteria andShippingStatusIsNotNull() {
            addCriterion("shipping_status is not null");
            return (Criteria) this;
        }

        public Criteria andShippingStatusEqualTo(Integer value) {
            addCriterion("shipping_status =", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotEqualTo(Integer value) {
            addCriterion("shipping_status <>", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusGreaterThan(Integer value) {
            addCriterion("shipping_status >", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("shipping_status >=", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusLessThan(Integer value) {
            addCriterion("shipping_status <", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusLessThanOrEqualTo(Integer value) {
            addCriterion("shipping_status <=", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusIn(List<Integer> values) {
            addCriterion("shipping_status in", values, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotIn(List<Integer> values) {
            addCriterion("shipping_status not in", values, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusBetween(Integer value1, Integer value2) {
            addCriterion("shipping_status between", value1, value2, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("shipping_status not between", value1, value2, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andPickupDateIsNull() {
            addCriterion("pickup_date is null");
            return (Criteria) this;
        }

        public Criteria andPickupDateIsNotNull() {
            addCriterion("pickup_date is not null");
            return (Criteria) this;
        }

        public Criteria andPickupDateEqualTo(Date value) {
            addCriterion("pickup_date =", value, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateNotEqualTo(Date value) {
            addCriterion("pickup_date <>", value, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateGreaterThan(Date value) {
            addCriterion("pickup_date >", value, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateGreaterThanOrEqualTo(Date value) {
            addCriterion("pickup_date >=", value, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateLessThan(Date value) {
            addCriterion("pickup_date <", value, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateLessThanOrEqualTo(Date value) {
            addCriterion("pickup_date <=", value, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateIn(List<Date> values) {
            addCriterion("pickup_date in", values, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateNotIn(List<Date> values) {
            addCriterion("pickup_date not in", values, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateBetween(Date value1, Date value2) {
            addCriterion("pickup_date between", value1, value2, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andPickupDateNotBetween(Date value1, Date value2) {
            addCriterion("pickup_date not between", value1, value2, "pickupDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNull() {
            addCriterion("delivery_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNotNull() {
            addCriterion("delivery_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeEqualTo(Date value) {
            addCriterion("delivery_time =", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotEqualTo(Date value) {
            addCriterion("delivery_time <>", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThan(Date value) {
            addCriterion("delivery_time >", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("delivery_time >=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThan(Date value) {
            addCriterion("delivery_time <", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanOrEqualTo(Date value) {
            addCriterion("delivery_time <=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIn(List<Date> values) {
            addCriterion("delivery_time in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotIn(List<Date> values) {
            addCriterion("delivery_time not in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeBetween(Date value1, Date value2) {
            addCriterion("delivery_time between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotBetween(Date value1, Date value2) {
            addCriterion("delivery_time not between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeIsNull() {
            addCriterion("delivery_confirm_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeIsNotNull() {
            addCriterion("delivery_confirm_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeEqualTo(Date value) {
            addCriterion("delivery_confirm_time =", value, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeNotEqualTo(Date value) {
            addCriterion("delivery_confirm_time <>", value, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeGreaterThan(Date value) {
            addCriterion("delivery_confirm_time >", value, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("delivery_confirm_time >=", value, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeLessThan(Date value) {
            addCriterion("delivery_confirm_time <", value, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeLessThanOrEqualTo(Date value) {
            addCriterion("delivery_confirm_time <=", value, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeIn(List<Date> values) {
            addCriterion("delivery_confirm_time in", values, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeNotIn(List<Date> values) {
            addCriterion("delivery_confirm_time not in", values, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeBetween(Date value1, Date value2) {
            addCriterion("delivery_confirm_time between", value1, value2, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryConfirmTimeNotBetween(Date value1, Date value2) {
            addCriterion("delivery_confirm_time not between", value1, value2, "deliveryConfirmTime");
            return (Criteria) this;
        }

        public Criteria andShippingCodeIsNull() {
            addCriterion("shipping_code is null");
            return (Criteria) this;
        }

        public Criteria andShippingCodeIsNotNull() {
            addCriterion("shipping_code is not null");
            return (Criteria) this;
        }

        public Criteria andShippingCodeEqualTo(String value) {
            addCriterion("shipping_code =", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeNotEqualTo(String value) {
            addCriterion("shipping_code <>", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeGreaterThan(String value) {
            addCriterion("shipping_code >", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_code >=", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeLessThan(String value) {
            addCriterion("shipping_code <", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeLessThanOrEqualTo(String value) {
            addCriterion("shipping_code <=", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeLike(String value) {
            addCriterion("shipping_code like", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeNotLike(String value) {
            addCriterion("shipping_code not like", value, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeIn(List<String> values) {
            addCriterion("shipping_code in", values, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeNotIn(List<String> values) {
            addCriterion("shipping_code not in", values, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeBetween(String value1, String value2) {
            addCriterion("shipping_code between", value1, value2, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingCodeNotBetween(String value1, String value2) {
            addCriterion("shipping_code not between", value1, value2, "shippingCode");
            return (Criteria) this;
        }

        public Criteria andShippingNameIsNull() {
            addCriterion("shipping_name is null");
            return (Criteria) this;
        }

        public Criteria andShippingNameIsNotNull() {
            addCriterion("shipping_name is not null");
            return (Criteria) this;
        }

        public Criteria andShippingNameEqualTo(String value) {
            addCriterion("shipping_name =", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameNotEqualTo(String value) {
            addCriterion("shipping_name <>", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameGreaterThan(String value) {
            addCriterion("shipping_name >", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_name >=", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameLessThan(String value) {
            addCriterion("shipping_name <", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameLessThanOrEqualTo(String value) {
            addCriterion("shipping_name <=", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameLike(String value) {
            addCriterion("shipping_name like", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameNotLike(String value) {
            addCriterion("shipping_name not like", value, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameIn(List<String> values) {
            addCriterion("shipping_name in", values, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameNotIn(List<String> values) {
            addCriterion("shipping_name not in", values, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameBetween(String value1, String value2) {
            addCriterion("shipping_name between", value1, value2, "shippingName");
            return (Criteria) this;
        }

        public Criteria andShippingNameNotBetween(String value1, String value2) {
            addCriterion("shipping_name not between", value1, value2, "shippingName");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("contract_no is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("contract_no =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("contract_no <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("contract_no >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("contract_no >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("contract_no <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("contract_no <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("contract_no like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("contract_no not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("contract_no in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("contract_no not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("contract_no between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("contract_no not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemIsNull() {
            addCriterion("order_sn_item is null");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemIsNotNull() {
            addCriterion("order_sn_item is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemEqualTo(String value) {
            addCriterion("order_sn_item =", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemNotEqualTo(String value) {
            addCriterion("order_sn_item <>", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemGreaterThan(String value) {
            addCriterion("order_sn_item >", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemGreaterThanOrEqualTo(String value) {
            addCriterion("order_sn_item >=", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemLessThan(String value) {
            addCriterion("order_sn_item <", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemLessThanOrEqualTo(String value) {
            addCriterion("order_sn_item <=", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemLike(String value) {
            addCriterion("order_sn_item like", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemNotLike(String value) {
            addCriterion("order_sn_item not like", value, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemIn(List<String> values) {
            addCriterion("order_sn_item in", values, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemNotIn(List<String> values) {
            addCriterion("order_sn_item not in", values, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemBetween(String value1, String value2) {
            addCriterion("order_sn_item between", value1, value2, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andOrderSnItemNotBetween(String value1, String value2) {
            addCriterion("order_sn_item not between", value1, value2, "orderSnItem");
            return (Criteria) this;
        }

        public Criteria andPriceTimeIsNull() {
            addCriterion("price_time is null");
            return (Criteria) this;
        }

        public Criteria andPriceTimeIsNotNull() {
            addCriterion("price_time is not null");
            return (Criteria) this;
        }

        public Criteria andPriceTimeEqualTo(Date value) {
            addCriterion("price_time =", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeNotEqualTo(Date value) {
            addCriterion("price_time <>", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeGreaterThan(Date value) {
            addCriterion("price_time >", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("price_time >=", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeLessThan(Date value) {
            addCriterion("price_time <", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeLessThanOrEqualTo(Date value) {
            addCriterion("price_time <=", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeIn(List<Date> values) {
            addCriterion("price_time in", values, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeNotIn(List<Date> values) {
            addCriterion("price_time not in", values, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeBetween(Date value1, Date value2) {
            addCriterion("price_time between", value1, value2, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeNotBetween(Date value1, Date value2) {
            addCriterion("price_time not between", value1, value2, "priceTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIsNull() {
            addCriterion("delivery_no is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIsNotNull() {
            addCriterion("delivery_no is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoEqualTo(String value) {
            addCriterion("delivery_no =", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotEqualTo(String value) {
            addCriterion("delivery_no <>", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThan(String value) {
            addCriterion("delivery_no >", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_no >=", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThan(String value) {
            addCriterion("delivery_no <", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThanOrEqualTo(String value) {
            addCriterion("delivery_no <=", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLike(String value) {
            addCriterion("delivery_no like", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotLike(String value) {
            addCriterion("delivery_no not like", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIn(List<String> values) {
            addCriterion("delivery_no in", values, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotIn(List<String> values) {
            addCriterion("delivery_no not in", values, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoBetween(String value1, String value2) {
            addCriterion("delivery_no between", value1, value2, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotBetween(String value1, String value2) {
            addCriterion("delivery_no not between", value1, value2, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoIsNull() {
            addCriterion("displist_no is null");
            return (Criteria) this;
        }

        public Criteria andDisplistNoIsNotNull() {
            addCriterion("displist_no is not null");
            return (Criteria) this;
        }

        public Criteria andDisplistNoEqualTo(String value) {
            addCriterion("displist_no =", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotEqualTo(String value) {
            addCriterion("displist_no <>", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoGreaterThan(String value) {
            addCriterion("displist_no >", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoGreaterThanOrEqualTo(String value) {
            addCriterion("displist_no >=", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoLessThan(String value) {
            addCriterion("displist_no <", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoLessThanOrEqualTo(String value) {
            addCriterion("displist_no <=", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoLike(String value) {
            addCriterion("displist_no like", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotLike(String value) {
            addCriterion("displist_no not like", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoIn(List<String> values) {
            addCriterion("displist_no in", values, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotIn(List<String> values) {
            addCriterion("displist_no not in", values, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoBetween(String value1, String value2) {
            addCriterion("displist_no between", value1, value2, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotBetween(String value1, String value2) {
            addCriterion("displist_no not between", value1, value2, "displistNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNull() {
            addCriterion("trade_no is null");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNotNull() {
            addCriterion("trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNoEqualTo(String value) {
            addCriterion("trade_no =", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotEqualTo(String value) {
            addCriterion("trade_no <>", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThan(String value) {
            addCriterion("trade_no >", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("trade_no >=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThan(String value) {
            addCriterion("trade_no <", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThanOrEqualTo(String value) {
            addCriterion("trade_no <=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLike(String value) {
            addCriterion("trade_no like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotLike(String value) {
            addCriterion("trade_no not like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIn(List<String> values) {
            addCriterion("trade_no in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotIn(List<String> values) {
            addCriterion("trade_no not in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoBetween(String value1, String value2) {
            addCriterion("trade_no between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotBetween(String value1, String value2) {
            addCriterion("trade_no not between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andSizeMsgIsNull() {
            addCriterion("size_msg is null");
            return (Criteria) this;
        }

        public Criteria andSizeMsgIsNotNull() {
            addCriterion("size_msg is not null");
            return (Criteria) this;
        }

        public Criteria andSizeMsgEqualTo(String value) {
            addCriterion("size_msg =", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotEqualTo(String value) {
            addCriterion("size_msg <>", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgGreaterThan(String value) {
            addCriterion("size_msg >", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgGreaterThanOrEqualTo(String value) {
            addCriterion("size_msg >=", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgLessThan(String value) {
            addCriterion("size_msg <", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgLessThanOrEqualTo(String value) {
            addCriterion("size_msg <=", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgLike(String value) {
            addCriterion("size_msg like", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotLike(String value) {
            addCriterion("size_msg not like", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgIn(List<String> values) {
            addCriterion("size_msg in", values, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotIn(List<String> values) {
            addCriterion("size_msg not in", values, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgBetween(String value1, String value2) {
            addCriterion("size_msg between", value1, value2, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotBetween(String value1, String value2) {
            addCriterion("size_msg not between", value1, value2, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoIsNull() {
            addCriterion("begin_warehouse_no is null");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoIsNotNull() {
            addCriterion("begin_warehouse_no is not null");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoEqualTo(String value) {
            addCriterion("begin_warehouse_no =", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoNotEqualTo(String value) {
            addCriterion("begin_warehouse_no <>", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoGreaterThan(String value) {
            addCriterion("begin_warehouse_no >", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoGreaterThanOrEqualTo(String value) {
            addCriterion("begin_warehouse_no >=", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoLessThan(String value) {
            addCriterion("begin_warehouse_no <", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoLessThanOrEqualTo(String value) {
            addCriterion("begin_warehouse_no <=", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoLike(String value) {
            addCriterion("begin_warehouse_no like", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoNotLike(String value) {
            addCriterion("begin_warehouse_no not like", value, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoIn(List<String> values) {
            addCriterion("begin_warehouse_no in", values, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoNotIn(List<String> values) {
            addCriterion("begin_warehouse_no not in", values, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoBetween(String value1, String value2) {
            addCriterion("begin_warehouse_no between", value1, value2, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWarehouseNoNotBetween(String value1, String value2) {
            addCriterion("begin_warehouse_no not between", value1, value2, "beginWarehouseNo");
            return (Criteria) this;
        }

        public Criteria andShipWgtIsNull() {
            addCriterion("ship_wgt is null");
            return (Criteria) this;
        }

        public Criteria andShipWgtIsNotNull() {
            addCriterion("ship_wgt is not null");
            return (Criteria) this;
        }

        public Criteria andShipWgtEqualTo(BigDecimal value) {
            addCriterion("ship_wgt =", value, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtNotEqualTo(BigDecimal value) {
            addCriterion("ship_wgt <>", value, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtGreaterThan(BigDecimal value) {
            addCriterion("ship_wgt >", value, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ship_wgt >=", value, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtLessThan(BigDecimal value) {
            addCriterion("ship_wgt <", value, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ship_wgt <=", value, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtIn(List<BigDecimal> values) {
            addCriterion("ship_wgt in", values, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtNotIn(List<BigDecimal> values) {
            addCriterion("ship_wgt not in", values, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ship_wgt between", value1, value2, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andShipWgtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ship_wgt not between", value1, value2, "shipWgt");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceIsNull() {
            addCriterion("order_item_price is null");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceIsNotNull() {
            addCriterion("order_item_price is not null");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceEqualTo(BigDecimal value) {
            addCriterion("order_item_price =", value, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceNotEqualTo(BigDecimal value) {
            addCriterion("order_item_price <>", value, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceGreaterThan(BigDecimal value) {
            addCriterion("order_item_price >", value, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_item_price >=", value, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceLessThan(BigDecimal value) {
            addCriterion("order_item_price <", value, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_item_price <=", value, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceIn(List<BigDecimal> values) {
            addCriterion("order_item_price in", values, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceNotIn(List<BigDecimal> values) {
            addCriterion("order_item_price not in", values, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_item_price between", value1, value2, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andOrderItemPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_item_price not between", value1, value2, "orderItemPrice");
            return (Criteria) this;
        }

        public Criteria andSettleModeIsNull() {
            addCriterion("settle_mode is null");
            return (Criteria) this;
        }

        public Criteria andSettleModeIsNotNull() {
            addCriterion("settle_mode is not null");
            return (Criteria) this;
        }

        public Criteria andSettleModeEqualTo(String value) {
            addCriterion("settle_mode =", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotEqualTo(String value) {
            addCriterion("settle_mode <>", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeGreaterThan(String value) {
            addCriterion("settle_mode >", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeGreaterThanOrEqualTo(String value) {
            addCriterion("settle_mode >=", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeLessThan(String value) {
            addCriterion("settle_mode <", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeLessThanOrEqualTo(String value) {
            addCriterion("settle_mode <=", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeLike(String value) {
            addCriterion("settle_mode like", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotLike(String value) {
            addCriterion("settle_mode not like", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeIn(List<String> values) {
            addCriterion("settle_mode in", values, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotIn(List<String> values) {
            addCriterion("settle_mode not in", values, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeBetween(String value1, String value2) {
            addCriterion("settle_mode between", value1, value2, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotBetween(String value1, String value2) {
            addCriterion("settle_mode not between", value1, value2, "settleMode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeIsNull() {
            addCriterion("region_code is null");
            return (Criteria) this;
        }

        public Criteria andRegionCodeIsNotNull() {
            addCriterion("region_code is not null");
            return (Criteria) this;
        }

        public Criteria andRegionCodeEqualTo(String value) {
            addCriterion("region_code =", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotEqualTo(String value) {
            addCriterion("region_code <>", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeGreaterThan(String value) {
            addCriterion("region_code >", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeGreaterThanOrEqualTo(String value) {
            addCriterion("region_code >=", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeLessThan(String value) {
            addCriterion("region_code <", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeLessThanOrEqualTo(String value) {
            addCriterion("region_code <=", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeLike(String value) {
            addCriterion("region_code like", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotLike(String value) {
            addCriterion("region_code not like", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeIn(List<String> values) {
            addCriterion("region_code in", values, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotIn(List<String> values) {
            addCriterion("region_code not in", values, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeBetween(String value1, String value2) {
            addCriterion("region_code between", value1, value2, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotBetween(String value1, String value2) {
            addCriterion("region_code not between", value1, value2, "regionCode");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleIsNull() {
            addCriterion("over_trans_cycle is null");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleIsNotNull() {
            addCriterion("over_trans_cycle is not null");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleEqualTo(String value) {
            addCriterion("over_trans_cycle =", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleNotEqualTo(String value) {
            addCriterion("over_trans_cycle <>", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleGreaterThan(String value) {
            addCriterion("over_trans_cycle >", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleGreaterThanOrEqualTo(String value) {
            addCriterion("over_trans_cycle >=", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleLessThan(String value) {
            addCriterion("over_trans_cycle <", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleLessThanOrEqualTo(String value) {
            addCriterion("over_trans_cycle <=", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleLike(String value) {
            addCriterion("over_trans_cycle like", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleNotLike(String value) {
            addCriterion("over_trans_cycle not like", value, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleIn(List<String> values) {
            addCriterion("over_trans_cycle in", values, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleNotIn(List<String> values) {
            addCriterion("over_trans_cycle not in", values, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleBetween(String value1, String value2) {
            addCriterion("over_trans_cycle between", value1, value2, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andOverTransCycleNotBetween(String value1, String value2) {
            addCriterion("over_trans_cycle not between", value1, value2, "overTransCycle");
            return (Criteria) this;
        }

        public Criteria andDriverNameIsNull() {
            addCriterion("driver_name is null");
            return (Criteria) this;
        }

        public Criteria andDriverNameIsNotNull() {
            addCriterion("driver_name is not null");
            return (Criteria) this;
        }

        public Criteria andDriverNameEqualTo(String value) {
            addCriterion("driver_name =", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameNotEqualTo(String value) {
            addCriterion("driver_name <>", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameGreaterThan(String value) {
            addCriterion("driver_name >", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameGreaterThanOrEqualTo(String value) {
            addCriterion("driver_name >=", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameLessThan(String value) {
            addCriterion("driver_name <", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameLessThanOrEqualTo(String value) {
            addCriterion("driver_name <=", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameLike(String value) {
            addCriterion("driver_name like", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameNotLike(String value) {
            addCriterion("driver_name not like", value, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameIn(List<String> values) {
            addCriterion("driver_name in", values, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameNotIn(List<String> values) {
            addCriterion("driver_name not in", values, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameBetween(String value1, String value2) {
            addCriterion("driver_name between", value1, value2, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverNameNotBetween(String value1, String value2) {
            addCriterion("driver_name not between", value1, value2, "driverName");
            return (Criteria) this;
        }

        public Criteria andDriverMobileIsNull() {
            addCriterion("driver_mobile is null");
            return (Criteria) this;
        }

        public Criteria andDriverMobileIsNotNull() {
            addCriterion("driver_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andDriverMobileEqualTo(String value) {
            addCriterion("driver_mobile =", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileNotEqualTo(String value) {
            addCriterion("driver_mobile <>", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileGreaterThan(String value) {
            addCriterion("driver_mobile >", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileGreaterThanOrEqualTo(String value) {
            addCriterion("driver_mobile >=", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileLessThan(String value) {
            addCriterion("driver_mobile <", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileLessThanOrEqualTo(String value) {
            addCriterion("driver_mobile <=", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileLike(String value) {
            addCriterion("driver_mobile like", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileNotLike(String value) {
            addCriterion("driver_mobile not like", value, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileIn(List<String> values) {
            addCriterion("driver_mobile in", values, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileNotIn(List<String> values) {
            addCriterion("driver_mobile not in", values, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileBetween(String value1, String value2) {
            addCriterion("driver_mobile between", value1, value2, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andDriverMobileNotBetween(String value1, String value2) {
            addCriterion("driver_mobile not between", value1, value2, "driverMobile");
            return (Criteria) this;
        }

        public Criteria andCarNumberIsNull() {
            addCriterion("car_number is null");
            return (Criteria) this;
        }

        public Criteria andCarNumberIsNotNull() {
            addCriterion("car_number is not null");
            return (Criteria) this;
        }

        public Criteria andCarNumberEqualTo(String value) {
            addCriterion("car_number =", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotEqualTo(String value) {
            addCriterion("car_number <>", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberGreaterThan(String value) {
            addCriterion("car_number >", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberGreaterThanOrEqualTo(String value) {
            addCriterion("car_number >=", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLessThan(String value) {
            addCriterion("car_number <", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLessThanOrEqualTo(String value) {
            addCriterion("car_number <=", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLike(String value) {
            addCriterion("car_number like", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotLike(String value) {
            addCriterion("car_number not like", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberIn(List<String> values) {
            addCriterion("car_number in", values, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotIn(List<String> values) {
            addCriterion("car_number not in", values, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberBetween(String value1, String value2) {
            addCriterion("car_number between", value1, value2, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotBetween(String value1, String value2) {
            addCriterion("car_number not between", value1, value2, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }
    }

    /**
     * order_depot_ship
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title order_depot_ship表的实体类
     * @description order_depot_ship
     * @version 1.0
     * @author yaokan
     * @date 2021-01-08 17:27:05
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
